Physical design approaches for column-stores
نویسندگان
چکیده
منابع مشابه
Vectorwise: Beyond Column Stores
This paper tells the story of Vectorwise, a high-performance analytical database system, from multiple perspectives: its history from academic project to commercial product, the evolution of its technical architecture, customer reactions to the product and its future research and development roadmap. One take-away from this story is that the novelty in Vectorwise is much more than just column-s...
متن کاملFast Column Scans: Paged Indices for In-Memory Column Stores
Commodity hardware is available in configurations with huge amounts of main memory and it is viable to keep large databases of enterprises in the RAM of one or a few machines. Additionally, a reunification of transactional and analytical systems has been proposed to enable operational reporting on the most recent data. In-memory column stores appeared in academia and industry as a solution to h...
متن کاملColumn Stores for Wide and Sparse Data
While it is generally accepted that data warehouses and OLAP workloads are excellent applications for column-stores, this paper speculates that column-stores may well be suited for additional applications. In particular we observe that column-stores do not see a performance degradation when storing extremely wide tables, and column-stores handle sparse data very well. These two properties lead ...
متن کاملPositional Delta Trees for Updating Column Stores
In this talk we introduce a datastructure, the positional delta tree (PDT), for maintaining differential updates against a read-optimized, column-oriented, relational DBMS, and present techniques for merging such updates into an ongoing table scan, to provide an up-to-date view of the data stored in the database. Traditionally, transaction processing systems have been built on top of row-orient...
متن کاملOrder preserving encryption for wide column stores
Order-preserving encryption (OPE) allows encrypting without losing information about the order relation between the encrypted data items. Thus, the execution of compare, order and grouping operations can be done like on plaintext data. In particular it allows databases to do range queries over encrypted data, which is a useful feature especially for cloud databases that usually run in untrusted...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: SPIIRAS Proceedings
سال: 2014
ISSN: 2078-9599,2078-9181
DOI: 10.15622/sp.30.13